alter table stg_ie_demogfeed Add
    [StemCells] VARCHAR(1),
    [BillIndicator] VARCHAR(1),
    [PILoginId] VARCHAR(5),
    [CustomerID] VARCHAR(15),
    [PrimarySponsorId] VARCHAR(15),
    [PrimarySponsorName] VARCHAR(15),
    [FARateType] VARCHAR(3),
    [FABaseId] VARCHAR(5),
    [ProtocolId] VARCHAR(15),
    [DefaultFund] VARCHAR(6),
    [SubAwardNumber] VARCHAR(20),
    [TeamMember1] VARCHAR(25),
    [ProjectRole1] VARCHAR(15),
    [TeamMember2] VARCHAR(25),
    [ProjectRole2] VARCHAR(15)

go
alter table stg_ie_demogfeed alter column [folder_number] varchar(15) 
go
alter table stg_ie_demogfeed alter column [PreviousFolderNumber] varchar(15) 
go
alter table stg_ie_demogfeed add [IsResearchProject] bit 
go
alter table AgrFundOverheadClassification Add [IsResearchProject] bit
go

Insert into AgrFundOverheadClassification(PSCode,PSDescription,SalaryGridColumnId,IsResearchProject)
select FundCode,Description,SalaryGriColumn,0 from AgrFundOverheadClassification1
Go

update AgrFundOverheadClassification set [IsResearchProject] = 0 
go

update AgrFundOverheadClassification set [IsResearchProject] = 1 where PSCode in ('068','070','071','072')
go